SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
and (bedrooms >='4') and (bedrooms >='4')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:For the first time in nearly 250 years, this remarkable 1780 colonial is being offered for sale. Thoughtfully cared for by the same family for generations, this exceptional 52-acre estate offers a rare opportunity to own a piece of New Hampshire history in the heart of Lyme. As you pull into the driveway, you're welcomed by rolling fields, mature hardwoods, and the peaceful setting that makes this property truly special. Inside, you'll find hand-hewn beams, wide pine floors, abundant natural light, four bedrooms, two bathrooms, a full basement, and timeless craftsmanship that reflects the history and character of this remarkable home. A drilled well, newer septic system, and an automatic-feed pellet furnace with oil baseboard backup provide modern convenience while complementing the home's historic character. Step outside to discover a four-stall horse barn complete with a tack room, fenced riding area, a network of mowed trails, a four-bay pole barn, multiple outbuildings, an oversized garage equipped with a professional-grade lift capable of servicing one ton trucks, and a fenced backyard. Beyond the buildings, the 52 acres offer a beautiful blend of open fields and mature hardwood forest, all enrolled in Current Use, creating plenty of room for horses, recreation, farming, or simply enjoying the surrounding landscape. Despite its private country setting, you're just 10 minutes from Lyme Elementary and Middle School, 15 minutes from Hanover, Dartmouth College, and I-91, and only 20 minutes from Dartmouth Health.
Description:Discover a quietly captivating Contemporary, where natural light pours in and the landscape becomes an ever-present part of the experience. Nearly every room frames a view, inviting you to slow down, settle in, and savor the setting. Thoughtfully designed gathering spaces offer both openness and intimacy. Host dinners in the formal dining room, linger over morning coffee in the breakfast nook, or curl up by the fire as the hillside shifts with the seasons. With generous proportions, the living areas adapt beautifully, whether entertaining, unwinding, or simply living with ease. For those who work from home, a full-size office with built-in bookshelves and expansive windows provides an inspiring place to spend your days. The kitchen is functional, crafted for those who love to cook and connect. A nearby pantry and direct-access mudroom streamline daily routines and arrivals. The east wing features three main-level bedrooms and two full baths, creating both comfort and flexibility. Upstairs, the primary suite feels like a private retreat; wrapped in windows on three sides, filled with soft light, and oriented toward serene northern views. A walk-in closet and full bath with a double vanity complete this sanctuary-like space. A full unfinished basement offers abundant storage, laundry, and direct outdoor access. Outside, rolling lawn, mature landscaping, a solar tracker, and apple trees blend seamlessly with the open field beyond.
Description:Located off of picturesque River Road in the lovely cul-de-sac neighborhood of Purling Brooks, this spacious, light-filled five bedroom, five bathroom home offers an exceptional blend of comfort, flexibility, and natural beauty. A welcoming front porch overlooking mature gardens creates a perfect spot to relax and enjoy the peaceful surroundings and expansive yard. The neighborhood abuts conservation land and scenic walking trails. A standout feature is the private accessory dwelling unit (ADU), with its own kitchen, living room, bedroom, bathroom and laundry- a versatile space for guests, extended family, a nanny, or potential rental income. The main home’s open-concept kitchen flows seamlessly into a spacious living room highlighted by soaring cathedral ceilings and a cozy propane fireplace. From the living room, step into the inviting three-season screened porch—an ideal retreat for relaxing, entertaining, or enjoying the private surrounding yard. The main level also includes a formal dining room, comfortable living room and a bedroom, which could easily serve as a private office or bonus room. Upstairs, the expansive primary bedroom ensuite features three walk-in closets, complemented by two additional bedrooms, a bathroom, a dedicated office or activity area, and a convenient second-floor laundry room. The large finished basement provides abundant space for recreation, entertainment, a potential sixth bedroom, and storage. Set in a desirable neighborhood with direct access to nature, this exceptional home offers space and versatility. A truly wonderful place to call home. Seller is a licensed real estate agent.
Description:Set on 40+/- private acres in Hanover, this exceptional 4 bedroom, 3.5 bath home offers breathtaking long range mountain views, stunning sunsets, and peaceful field vistas. Enjoy the beauty of every season from your own backyard, surrounded by perennial gardens, abundant wildlife, and the sounds of birdsong. As day turns to night, take in spectacular stargazing, where the stars shine brightly above the surrounding mountain and fields. Filled with natural light, nearly every room captures stunning views of the surrounding mountains, fields, and landscape. Inside, you'll find hardwood and tile floors, a spacious laundry room, and a chef’s kitchen featuring beautiful quartz countertops and ample space for gathering and entertaining. Step directly from the kitchen onto the expansive deck, where you can enjoy your morning coffee, watch wildlife, and take in the spectacular scenery. The inviting sunroom provides another peaceful space to relax and appreciate the ever changing views throughout the year. Cozy up by the woodstove on winter days while enjoying the warmth and charm of this thoughtfully designed home. Additional features include a 2 car garage, abundant attic storage, and a partially finished walkout basement complete with a full bath ideal for a game room, home gym, guest space, or recreation area. Step outside to the expansive yard where panoramic mountain and field views stretch for miles. With easy access to hiking trails right from your doorstep, outdoor enthusiasts will appreciate the opportunity to explore nature without ever getting in the car. Located just minutes from Hanover, Dartmouth, shopping, dining, and recreation, this property offers a rare combination of privacy, natural beauty, and convenience in one of the Upper Valley's most sought-after locations. Whether enjoying a sunset from the deck or sunroom, relaxing by the woodstove, or exploring the surrounding trails, this remarkable property is a true Upper Valley retreat.
Description:3 Lewin Road checks every box and then some. Turn-key, beautifully updated, and just a few blocks from Hanover's Main Street, this 4-bedroom, 3.5-bath Cape is deceptively spacious and unmistakably well-done. A complete 2025 reimagination brought a showstopper gourmet kitchen -quartzite countertops, paneled Sub-Zero, induction range with pro-bake and air fry, retractable brass pot-filler, custom cabinetry, and concealed ventilation - along with a long list of stunning updates that complement the flexible floor plan, including primary suites on both levels. The main floor open-concept living space flows seamlessly through doors that open directly to the backyard, where a full-length deck, pergola, garden shed, and fire pit area create an outdoor entertaining sequence for every season. Upstairs, three generously sized bedrooms offer comfortable separation. The expansive basement delivers serious storage and potential to expand your living space. An attached one-car garage rounds out the package. Steps from the Mink Brook trailhead, close to the Connecticut River, Hanover High School, and Dartmouth College Campus, it's the rare property that it earns that in-town cottage charm without any of the compromise. The list of recent renovations and improvements to this 3-story property is long and ready to be enjoyed by the next homeowners for years to come.